﻿IF (NOT EXISTS
	(SELECT * FROM syscolumns
	 WHERE id=object_id('CaseNotes') AND name='AuthorID'))
BEGIN
	ALTER TABLE CaseNotes ADD AuthorID bigint NULL REFERENCES Users(OID)
END
GO

IF (NOT EXISTS
	(SELECT * FROM syscolumns
	 WHERE id=object_id('GrantNotes') AND name='AuthorID'))
BEGIN
	ALTER TABLE GrantNotes ADD AuthorID bigint NULL REFERENCES Users(OID)
END
GO

IF (NOT EXISTS
	(SELECT * FROM syscolumns
	 WHERE id=object_id('ServiceManNotes') AND name='AuthorID'))
BEGIN
	ALTER TABLE ServiceManNotes ADD AuthorID bigint NULL REFERENCES Users(OID)
END
GO
